UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xrpji+BqQF61f1JXw0vvLQfGN9fqDuisjzAjvZus9SE='
WHERE
key_id = 'dc147602aee8bc90f0c3ad39e18d76c4483c246f3855ee3b5a412228860caefe'
AND (
token = 'xrpji+BqQF61f1JXw0vvLQfGN9fqDuisjzAjvZus9SE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)