UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'i2L97fh5CAAWBRWNYle4rwlBAgrmWXarQZXU5oSmSeE=' 
WHERE 
  key_id = '9bc9bdce7e91df1dd67c335f6c29ede3c7f8f12cdb3f9581657fa64b21b8aed2' 
  AND (
    token = 'i2L97fh5CAAWBRWNYle4rwlBAgrmWXarQZXU5oSmSeE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032