UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uXKYig1xnzL5+UumV0LlHzFdS8IvNWAJBwlB1YpjNks='
WHERE
key_id = '492985890259e29a5e237c7aec69fa7ccb8e6adc2701f1cd194c5b13be9d0eb6'
AND (
token = 'uXKYig1xnzL5+UumV0LlHzFdS8IvNWAJBwlB1YpjNks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)