UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vFaQ2abx0AJmhEbctgEQBpzHgBa/Oq888GJIVBuMjjk=' 
WHERE 
  key_id = 'd628511b3a092b29c614d04b69ebd31af27adabb1e4858017560edeee3af087d' 
  AND (
    token = 'vFaQ2abx0AJmhEbctgEQBpzHgBa/Oq888GJIVBuMjjk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033