UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VjDIOvhmfsxPCC2qGdEOBTCv1ofYIuO6OEFBir3FkHw='
WHERE
key_id = '15d4d1d8e236088df268e9a37ee856eb5725e5ef976e61c6044a6ff8e911d6eb'
AND (
token = 'VjDIOvhmfsxPCC2qGdEOBTCv1ofYIuO6OEFBir3FkHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)