UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GXgJLgorB8owKv2KsHDJMpInZTCSMxAEGaYeo9KCho='
WHERE
key_id = '938d7ce75f14efa6907d2dd7db0af7b24f126c67ec36eadf64b72529ad2d6e54'
AND (
token = '6GXgJLgorB8owKv2KsHDJMpInZTCSMxAEGaYeo9KCho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)