UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b8wIHhkQDL2hJumfKzSnwAlX4bvmet32aliGqWLRIZ4='
WHERE
key_id = '70ccbd6ca6a9eb8e0a3805c9b7f454ab577977ce705e0180eb83a8dfa848ae78'
AND (
token = 'b8wIHhkQDL2hJumfKzSnwAlX4bvmet32aliGqWLRIZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)