UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKcvp7tq+BcXQ9SVwm355OPXxYm1rKgRuSUi5QKD5ks='
WHERE
key_id = '394db1769aaab56b4d0faf46f320d2f23ab8de7642f51bb9b89fe549c5b5390e'
AND (
token = 'zKcvp7tq+BcXQ9SVwm355OPXxYm1rKgRuSUi5QKD5ks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)