UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKrP5TIph1peU5FLWFeI4oimbGTo0Kbfwqk5A5RdFuc='
WHERE
key_id = '7b414c238c22d8a6b765002182e3fda1772156d81edbec5cb24157f9170752b0'
AND (
token = 'nKrP5TIph1peU5FLWFeI4oimbGTo0Kbfwqk5A5RdFuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)