UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OCd+NloOPdIokONK7K8pZcVMd798HXfjJ1SSkn8ky1c='
WHERE
key_id = '3564cadae9135dd2351589c78ef3ee9215db832a54e507b46bab2c701cd7c951'
AND (
token = 'OCd+NloOPdIokONK7K8pZcVMd798HXfjJ1SSkn8ky1c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)