UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AP0Px1OHOYZGIxHpjwvq8l+7ULMkJqlkTZu3+92BAlw='
WHERE
key_id = 'b7d78e209e139ef2a122e8470b47a772067f44d46dcf13f30dd4faf21927fd99'
AND (
token = 'AP0Px1OHOYZGIxHpjwvq8l+7ULMkJqlkTZu3+92BAlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)