UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ySDQotK++XifWNFV3thMNkGYmYHNGhngZNiVrHJHduo='
WHERE
key_id = 'af476b132577cb2d26076d5cda86fdeb0a71ee397dc3396667ab130639e6a2a2'
AND (
token = 'ySDQotK++XifWNFV3thMNkGYmYHNGhngZNiVrHJHduo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)