UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'twsD/PqGZ73dqnOpVOIVaDgKe9m97VBS5WCeNYxcKPA='
WHERE
key_id = 'e2447da7e77942ad20622b38efac3e7d07fa38a030b775694e79255e5eee74a8'
AND (
token = 'twsD/PqGZ73dqnOpVOIVaDgKe9m97VBS5WCeNYxcKPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)