UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1aHXNCjccoxpyb0BiXUsIXrotmJ0xwqPTDCjYwM9jcI=' 
WHERE 
  key_id = 'fac7ddacf59f9cfea9112aa414ac297c4c2868caa08f4c076bc36ffc62206167' 
  AND (
    token = '1aHXNCjccoxpyb0BiXUsIXrotmJ0xwqPTDCjYwM9jcI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039