UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z79t0kjulPlXNKClR0vNMK66zD/fKCh85vueQThr+3w='
WHERE
key_id = 'a24da4f36e836a2379829bc2ec84810e7a65b2ade1cec64f0cbb00b4300aa6f9'
AND (
token = 'z79t0kjulPlXNKClR0vNMK66zD/fKCh85vueQThr+3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)