UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cQKPK7cWPbhdr8VO8mvohQrv5H+qbERpZ/7X808UIPk=' 
WHERE 
  key_id = '84920cc744063659be5b6139b86f0036dc61bcfabaf6f52f61142432c1784e8b' 
  AND (
    token = 'cQKPK7cWPbhdr8VO8mvohQrv5H+qbERpZ/7X808UIPk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035