UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5fppHbXgKGXbWeCvxrtCIEsf9SGHvbxO0XOmabdOPPE='
WHERE
key_id = 'ceda96ba0e7af955e880479ae308cd3a75d70c412644a01a33ae59f469bcc207'
AND (
token = '5fppHbXgKGXbWeCvxrtCIEsf9SGHvbxO0XOmabdOPPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)