UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z1Tl8W2Kh/Lomd6DUcNxaQ1rUeynjYl6ppequLyfnOY='
WHERE
key_id = 'd38e6b6463a095f04c88ce5ac224450133bda3fe9bce4f714f80f119242443b7'
AND (
token = 'Z1Tl8W2Kh/Lomd6DUcNxaQ1rUeynjYl6ppequLyfnOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)