UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VJHFcZeBewYWrwGURunx8JCaFrijmK87oGpkV7fYOXU='
WHERE
key_id = '9ae3a5ef5be9c17f03917dae6eddbacc8307a7f46b94745350f95255d1b73061'
AND (
token = 'VJHFcZeBewYWrwGURunx8JCaFrijmK87oGpkV7fYOXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)