UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZLKYANusDlSw3ZYjoGpl9XoIJfLwjKHtVcMd3hIRCRk='
WHERE
key_id = '393880a12e61a6d0ccc250ad88828392a3e1dde678e506474ea0a96315fe273e'
AND (
token = 'ZLKYANusDlSw3ZYjoGpl9XoIJfLwjKHtVcMd3hIRCRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)