UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KRovW1zYmWU+fsV9tJf5XXwLgVp5ngb3A+qchWvhEoY='
WHERE
key_id = '628770975022b51af78b07abcd7d6305c1254b78b894adc2f02f0d5c95c7c22c'
AND (
token = 'KRovW1zYmWU+fsV9tJf5XXwLgVp5ngb3A+qchWvhEoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)