UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rjJ70J92XxNDeIt9tCMmoqyK5yejgJhUt5yuzjnYj8k='
WHERE
key_id = '9cd5be24b40d3123cbeaae60452946089499b0a362243af7ed6a17e388d4cc4d'
AND (
token = 'rjJ70J92XxNDeIt9tCMmoqyK5yejgJhUt5yuzjnYj8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)