UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NL20UrgL0BaWqQIyo0l1zJlR9pZzGhsGonq5CNINSR4=' 
WHERE 
  key_id = '885460663587297bcc7f16fb5a26ef05a9767c0895ec038f6e95c0523e988aed' 
  AND (
    token = 'NL20UrgL0BaWqQIyo0l1zJlR9pZzGhsGonq5CNINSR4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028