UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVgbA3rJ5caYuoZVD5lueJnRvMrl1PCNZXnAy6iApok='
WHERE
key_id = '9ae114cef72123012070b792fa251a790e58155562da08f5e74bde4b2813d954'
AND (
token = 'ZVgbA3rJ5caYuoZVD5lueJnRvMrl1PCNZXnAy6iApok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)