UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yD6qjn918MBK0lsHLga+eVa2G43LVwsOS1elGMhho4g='
WHERE
key_id = 'cee2cb0bb5606a2b1613a745a27e39d6b94b72ce8f43eb26832ebe0b50a02fd4'
AND (
token = 'yD6qjn918MBK0lsHLga+eVa2G43LVwsOS1elGMhho4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)