UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NU3lpsEt5ifaxcRvrClW6BEoXRdMd1U3F2o81VC93Fk='
WHERE
key_id = 'd0fcafda7a2240b34b11b92a43dd7d884c5ed37e24581b93d00fe49827b10170'
AND (
token = 'NU3lpsEt5ifaxcRvrClW6BEoXRdMd1U3F2o81VC93Fk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)