UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/A9K2a4RjBmjbGpRAwYI/fmjtf256yKdsDLPgBd5VSA=' 
WHERE 
  key_id = '906352ed3675095bcf30373904bdd987963922bfe4659b208761956aaf6e7687' 
  AND (
    token = '/A9K2a4RjBmjbGpRAwYI/fmjtf256yKdsDLPgBd5VSA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034