UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tLKY9FTf5opMI2sc1ca+X/TTH5IyGPWPzuNgAmUhV40='
WHERE
key_id = '6f7e5735b07cb582c7d5adf130b13f435acb9a0bf1ce52d9dccb7e04e7253d2e'
AND (
token = 'tLKY9FTf5opMI2sc1ca+X/TTH5IyGPWPzuNgAmUhV40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)