UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qU1g+VNHs1w2UkifnzD+qO7V+POg5HyjpsJwb0iI8GU='
WHERE
key_id = 'e9b8f048e41d88eb5dffb34de708397b583ded0d09ffe6dcf1c07cf1718c345d'
AND (
token = 'qU1g+VNHs1w2UkifnzD+qO7V+POg5HyjpsJwb0iI8GU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)