UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HDZWq7G9pafE2gEHqgG5fy9YsLZvKoVALDGes7R6QQI='
WHERE
key_id = '1d81cc33041167339a7633a4fcea8c5512f2409e1fe1aa18f9c940d3956ecb3a'
AND (
token = 'HDZWq7G9pafE2gEHqgG5fy9YsLZvKoVALDGes7R6QQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)