UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0lGrWrg7yPYKJKJCiGrt0B1UKY+XJhynyaqXp8HNtGg='
WHERE
key_id = '8cb3250c6a537afce66c0a18203acd688623ac0ebec791bab16abee9fb5a5df0'
AND (
token = '0lGrWrg7yPYKJKJCiGrt0B1UKY+XJhynyaqXp8HNtGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)