UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CrK63xdbiENzUzIV74WiDa+ZDUYYmZht0x4O0+KxrUE='
WHERE
key_id = 'c76ba4d31ac73f7512899c067edef5bb77e96b388ceec42cbd356693fa24bbc9'
AND (
token = 'CrK63xdbiENzUzIV74WiDa+ZDUYYmZht0x4O0+KxrUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)