UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8h3xjFrY1ptvVlqSfKI0JpZNbE0ThvB5FNQpyyghDuQ='
WHERE
key_id = '4bc114b42ae030eee89c0a4fec2034c77c1e1d92736eaad8ffce85ed4f5fc345'
AND (
token = '8h3xjFrY1ptvVlqSfKI0JpZNbE0ThvB5FNQpyyghDuQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)