UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0AiBvStlj0CW2FylK9/S7FJ5d6XcqAEbcaPSI9H1OUI=' 
WHERE 
  key_id = '5992943874c6c375641ff6a0d5ecc7c1a739b03502328f5dd0b762c8924e7167' 
  AND (
    token = '0AiBvStlj0CW2FylK9/S7FJ5d6XcqAEbcaPSI9H1OUI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027