UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rm7IqDgXGENY8iXvw42KQNjmlYHfDxhi7laET9aBqn4='
WHERE
key_id = 'cc960f1d4f8aeac8800b0f7defdd7e112c354adab5cf224326e4a67b53ad5c9d'
AND (
token = 'rm7IqDgXGENY8iXvw42KQNjmlYHfDxhi7laET9aBqn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)