UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mDdJGhX6Rj6vWR46vtZ4digyvFLDH1sx9jArsA4UJcE='
WHERE
key_id = '16c362da1d17f034d008b6c010d79575f5c088a0fd430c4b39fc4b13c45144b0'
AND (
token = 'mDdJGhX6Rj6vWR46vtZ4digyvFLDH1sx9jArsA4UJcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)