UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xFD3Q1FwUCsCbAT6TFw7qnWKk8aykwdGv7z2ASg2sAc='
WHERE
key_id = 'be4ebccd23812553410597d45df53ca839771eecd7c34cecb58802d74c87f14c'
AND (
token = 'xFD3Q1FwUCsCbAT6TFw7qnWKk8aykwdGv7z2ASg2sAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)