UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p6vkE9plpTNR0uygn5pXAtsAcVIAeF5vjMvDYaC8moo='
WHERE
key_id = '72ef67ef4b7413574ac8a1d67fe34f5d2ef97d6b4695b132a9c069bb1afcb786'
AND (
token = 'p6vkE9plpTNR0uygn5pXAtsAcVIAeF5vjMvDYaC8moo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)