UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kooVP9pknlIGUgu4sTu5XlkTr2bwSTu964A4IVjsGhQ=' 
WHERE 
  key_id = '1674295cd4371d96121ac11e7e2c6be35b2bbcb0abbb1b7ad72e84eceb02e46b' 
  AND (
    token = 'kooVP9pknlIGUgu4sTu5XlkTr2bwSTu964A4IVjsGhQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027