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