UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ErYOWG5U6U0mg453qKdbT3tmYvP8C+O0LgcsKNWYU0='
WHERE
key_id = '139d3a1e5c6a1b91665872d31240752e6723f62b6da4f5196a833dfbd45c6823'
AND (
token = '7ErYOWG5U6U0mg453qKdbT3tmYvP8C+O0LgcsKNWYU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)