UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qNa3AY9dq0lGDyoGOG0D7Lodisu83UUV8rGdxnc+qzs='
WHERE
key_id = 'a652447377b92f46e09b6aeef055ace82bffed7ead7ce6ab71ed20c6a86b8001'
AND (
token = 'qNa3AY9dq0lGDyoGOG0D7Lodisu83UUV8rGdxnc+qzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)