UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jw9gfzTVWrvc10DLo5sVCOCWoSJPmlMhTTHd66MdMTc='
WHERE
key_id = 'ccda7300b5b1054f731356136e1673f6d299468e509f22747066840e842b92ed'
AND (
token = 'jw9gfzTVWrvc10DLo5sVCOCWoSJPmlMhTTHd66MdMTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)