UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J4x/0cpLiqHicr748My5PeME7hadO/s2N+9WxaN3pwE='
WHERE
key_id = 'a58a223b64539afc2ed8eee915a67e678c72f0a8e47f5f65178e05d5e63224c4'
AND (
token = 'J4x/0cpLiqHicr748My5PeME7hadO/s2N+9WxaN3pwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)