UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n4IkIxPkvYwTlVZkvAnpvcxGC+W1AyHVU20YxxiSxAo='
WHERE
key_id = '65bfbdb5c20f82b36605bfbb10c0d9dbb487e78c9bb2646b80db6b8c188667a4'
AND (
token = 'n4IkIxPkvYwTlVZkvAnpvcxGC+W1AyHVU20YxxiSxAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)